Chess Individual - Major Section

Name	Club	Trophies won	Years Won"; while ($rmajor = mysql_fetch_array($major)) { echo "
".$rmajor['name']."	".$rmajor['team']."	".$rmajor['number']."	".$rmajor['year'];} echo "

"; echo "

Chess Individual - Minor Section

Name	Club	Trophies won	Years Won"; while ($rminor = mysql_fetch_array($minor)) { echo "
".$rminor['name']."	".$rminor['team']."	".$rminor['number']."	".$rminor['year'];} echo "

"; echo "

Chess Teams

Club	Trophies won	Years Won"; while ($rchessteam = mysql_fetch_array($chessteam)) { echo "
".$rchessteam['team']."	".$rchessteam['number']."	".$rchessteam['year'];} echo "

"; echo "

Draughts Individual

Name	Club	Trophies won	Years Won"; while ($rdraughtsind = mysql_fetch_array($draughtsind)) { echo "
".$rdraughtsind['name']."	".$rdraughtsind['team']."	".$rdraughtsind['number']."	".$rdraughtsind['year'];} echo "

"; echo "

Draughts Teams

Club	Trophies won	Years Won"; while ($rdraughtsteam = mysql_fetch_array($draughtsteam)) { echo "
".$rdraughtsteam['team']."	".$rdraughtsteam['number']."	".$rdraughtsteam['year'];} echo "

"; echo "

West V East Regional Match for G.D. Burnett Trophy

Club	Trophies won	Years Won"; while ($rwestveast = mysql_fetch_array($westveast)) { echo "
".$rwestveast['team']."	".$rwestveast['number']."	".$rwestveast['year'];} echo "

"; echo "

Chess Blitz

Name	Club	Trophies won	Years Won"; while ($rblitz = mysql_fetch_array($blitz)) { echo "
".$rblitz['name']."	".$rblitz['team']."	".$rblitz['number']."	".$rblitz['year'];} echo "

"; if ($_COOKIE['logged_in']=='Y' && $_COOKIE['username']=='admin') {echo "Name Club CompetitionChess CongressMajorMinorChess TeamDraughts IndividualDraughts TeamWest V EastChess BlitzYear

";} if (isset($_GET['enta'])){ $poll=mysql_query("SELECT * FROM winners WHERE comp='$_GET[comp]' and name='$_GET[nam]' and team='$_GET[enta]'") or die(mysql_error()); $inp=mysql_fetch_array($poll); if ($inp=="") {echo "nothing"; mysql_query("INSERT INTO winners (comp, name, team, number, year) VALUES ('$_GET[comp]', '$_GET[nam]', '$_GET[enta]', 1, '$_GET[year]')") or die(mysql_error());} else {$cou=$inp['number']+1; echo $cou; $year=$inp['year'].", ".$_GET['year']; mysql_query("UPDATE winners SET number='$cou', year='$year' WHERE comp='$_GET[comp]' and name='$_GET[nam]' and team='$_GET[enta]' ");}} ?>

Go Back